Which one of the following could be achieved through the use of the Auto Fill feature?
A. Fit spreadsheet contents to a single page
B. Copy a cell comment to adjacent cells
C. Extend a sequential series of data
D. Automatically apply a filter to a set of data
查看答案
Two statements about spreadsheets follow. Is each statement true or false?
A. Statement 1 is true, Statement 2 is false
Both statements are true
C. Statement 1 is false, Statement 2 is true
D. Both statements are false
What is the correct formula to add the values in B12 and C13 and then multiply the result by the value in C25?
A. =B12+C13/C25
B. =B12+C13*C25
C. =(B12+C13)/C25
D. =(B12+C13)*C25
Hannah is working in a spreadsheet which contains the value of total sales for the year 20X7 in cell D70. Hannah has been instructed to calculate the 20X8 forecast sales figure, in cell F70, by adding 7.5% to the 20X7 total sales figure. Which one of the following would calculate the correct figure
A. =D70*1.75
B. =D70/1.075
C. =D70*1.075
D. =D70/1.75
What name is given to an automated set of commands saved for use in a spreadsheet?
A chart
B. A macro
C. A function
D. A formula