click below
click below
Normal Size Small Size show me how
Corrections
CA XL04
| Question | Answer |
|---|---|
| Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in excel? | B. Worksheet |
| Jennifer need to identify the values in column B for a sales report. Which type of entry should she use in the column header? | C. Lables |
| When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? | D. Relative Reference |
| What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address? | D. Worksheet Reference |
| Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n): | B. External Reference |
| Jennifer is calculating her GPA. if she uses "=(A1+A2+A3+A4)/4" , this is an example of which type of entry? | B. Formulas |