Computer Apps 2
How do you select multiple rows in a worksheet?
By selecting the rows while the Shift or Control key is pressed.
A cell in the third column and second row would have what address?
C2
What feature would you use to locate and replace all occurrences of one value with another?
Find and replace
What justification will place your data up against the right side of the cell?
Right-justified
What does it mean to "freeze" a row or column?
This makes sure that that column or row is always visible in the spread sheet.
Which of the following file extensions is NOT commonly used for spreadsheets?: xls, xlsx, pdf, ods.
Which of the following is a pre-built function that will perform a mathematical task or analyze data in most spreadsheets?: AVERAGE() SUM() COUNT()
All of these are true
What kind of character is found above each column and forms part of the address in Excel?
A letter
Which math operator is used to show multiplication in a spreadsheet formula?
Asterisk (*)
When writing your own formula, what symbol do you use at the beginning of the formula?
Equals Sign (=)
Which of the following is NOT a spreadsheet program?: OpenOffice Calc, Microsoft Excel, Google Sheets, Google Slides.
Google Slides
Which spreadsheet feature will let you rapidly fill many cells with the same or automatically adjusted data?
Quick Fill
If you wanted to sort data in reverse alphabetical order, which option would you choose?
Sort Z to A
If you enter a monetary value in a cell, why might you want to apply the Currency format to that cell?
So the value will appear with a dollar sign or other national symbol