Autofill Feature in Excel Assignment | Homework For You
June 8th, 2020
Question 8 1 pts In Excel, the autofill feature: Applies a border around selected cells. Copies and fills a formula down or across the page. O Fills the selected formatting down or across the page. Automatically adds a range of cell values.
Question 11 1 pts You use the fill handle to copy the formula =A55 down into the cell below. The result will be: The column reference will remain the same and the row reference will change O Both the column and row references will change The column reference will change and the row reference will remain the same O Both the row and column reference will remain the same
Question 12 1 pts Cell A27 contains the formula =’reference data’!$A$10. Which of the following statements is true? The contents of ‘reference data’!$A$10 will change if the formula in cell A27 changes Cell A27 contains a relative cell reference The contents of cell A27 will change if data in ‘reference data’!$A$10 changes Cell A27 is contained in a sheet called ‘reference data’
Question 13 1 pts Conditional formatting is a feature of excel spreadsheets. With regard to conditional formatting, which of the following statements is true? Conditional formatting enables the user to locate a particular format such as bold or italics when a particular condition is met. Conditional formatting allows you to highlight unusual cell values, and visualise the data using formatting such as colours and data bars. Conditional formatting can only be applied to a single cell at any one time. In Excel, the conditional formatting command can be selected from the ‘cells’ section of the home tab.Get Finance homework help today