Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.
What will be an ideal response?
- A formula specifies how to add, subtract, multiply, divide, or otherwise calculate the values in worksheet cells. A formula always begins with an equal sign (=) and can use cell references that point to the contents of other cells.
- A cell reference is the column and row location of a cell, for example, B1 and B2.
- How a formula uses cell references: The formula =B1-B2 subtracts the contents of cell B2 from the contents of cell B1 and displays the results in the active cell, for example, B3.
You might also like to view...
Choose the false statement.
(a) The input unit places information at the disposal of other units so that the information may be processed. (b) The output unit takes information from the mouse and keyboard. (c) The memory unit retains information that has already been processed until that information can be placed on output devices. (d) The ALU is responsible for performing calculations such as addition, subtraction, multiplication and division.
Critical Thinking QuestionsCase 6-1Bev has organized her thoughts and ideas for her new human resources presentation in a rough sketch outline document. At lunch today, she asks if you have any tips on a quick way to get from her sketch outline to a PowerPoint presentation. Next you suggest that Bev ____. a. print her formal outline and use it as a guide for creating her new slidesc. copy and paste the formal outline's first, second, and third level paragraphs into individual slidesb. open her formal outline in PowerPoint using the All Outlines option to add slides based on the outline to her new presentationd. hire someone to create her presentation
What will be an ideal response?
Using the fill handle on a cell containing a formula
A) has two or more sub-commands related to the command. B) changes the background color of the selected cells to yellow. C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula. D) cannot complete a sequence of dates in a column.
Application gateways are also known as application proxies
Indicate whether the statement is true or false.