WorksheetsSpreadsheet Basic Formulas & Functions
Total questions: 15
Worksheet time: 8mins
Which application is used to open a new spreadsheet?
Word
PowerPoint
Excel
Access
Which tab is used to insert a header?
Home
Insert
Design
Layout
Which group from the home tab will you find "Merge and center"?
Font
Styles
Clipboard
Alignment
To edit words in an active cell you need to double click the cell.
False
True
What does all formulas start with?
.
/
#
=
What function will add all the contents of a cell range?
=average
=sum
=count
=counta
What is an accounting border?
bottom line border
double bottom line border
top line and double bottom line border
top line border
Which of the following is an example of a cell range?
A3
3
A
A3:A134
To delete an entire column:
Click the column letter to highlight the column, right click and select delete
Click the column number to highlight the column, right click and select delete
How do you copy a formula?
Copy and paste
cut and paste
use the fill handle
retype the formula
On the home tab, which group is used to format data as a percent?
Clipboard
Number
Font
Paragraph
To apply a border, which group from the home tab is used?
Alignment
Font
Styles
Editing
Which function is used to calculate the average?
=max
=avg
=min
=average
Which function is used to calculate the highest number?
=max
=min
=count
Which function is used to calculate the lowest number?
=sum
=max
=min
