- Formulas in Excel start with
a. %
b. =
c. +
d. – - The default header for a worksheet is
a. Username
b. Date and Time
c. Sheet tab Name
d. None - Which of the following is not an option of the spelling dialog box?
a. Ignore
b. Ignore all
c. Edit
d. Change - Which of the following methods will not enter data in a cell?
a. Pressing the Esc key
b. Pressing an arrow key
c. Pressing the tab key
d. Clicking the enter button to the formula bar - The cell reference for cell range of G2 to M12 is _
a. G2.M12
b. G2;M12
c. G2:M12
d. G2-M12 - What is the keyboard shortcut for creating a chart from the selected cell range?
a. F2
b. F4
c. F8
d. F11 - The Software which contains rows and columns is called __
a. Database
b. Drawing
c. Spreadsheet
d. Word processing - You can group noncontiguous worksheets with
a. The alt+enter key
b. The ctrl key and mouse
c. The shift key and the mouse
d. The group button on the standard toolbar - What is the AutoComplete feature of Excel?
a. It automatically completes abbreviated words
b. It completes text entries that match an existing entry in the same column
c. It completes text and numeric entries that match an existing entry in the same column
d. It completes text entries that match an existing entry in the same worksheet - Which of the following is correct?
a. =AVERAGE(4, 5, 6, 7)
b. =AVERAGE(A1, B1, C1)
c. =AVERAGE(A1:A9, B1:B9)
d. =All of the above
Leave a Reply