37 Questions
What is the first character that must be included in a cell that contains a formula in Microsoft Excel?
An equal sign (=)
What happens if you do not include the equal sign (=) at the beginning of a formula in Microsoft Excel?
The formula will display the text of the formula only
What is the purpose of an Excel formula?
To tell Excel that a calculation needs to be performed
What is the term for the rules that govern the order in which Excel performs calculations in a formula?
Order of Operator Precedence
What happens when you edit an existing formula in Microsoft Excel?
The formula is updated instantly
What is the purpose of cell references in formula writing in Microsoft Excel?
To perform calculations using values in other cells
What is the purpose of prefixing a value in a cell with an apostrophe ( ' )?
To force a text value
What is the operator used for concatenation in Excel?
&
How do you select a cell in Excel?
By clicking on it once
What is the purpose of the formula bar in Excel?
To display the selected cell's contents
How do you modify the contents of a cell in Excel?
By double clicking on the cell
What is the data type of the values true and false?
Logical
What is the purpose of the now() function in Excel?
To return the current date and time
How do you move from cell to cell in Excel?
By pressing the arrow keys
What is the shape of the cursor when you want to resize a column?
Double headed arrow
How do you make a column wider?
Click the left mouse button and drag the separator to the right
What is the shortcut to add a new line inside a cell?
Alt + Enter
How do you select a large range of cells?
Click on the upper left cell and then hold the Shift key and click on the lower right cell
How do you select different non-contiguous areas of cells?
Hold the Ctrl key and click on each area
What happens when you double click on the separator between columns?
The column becomes exactly the correct width
How do you make a row taller or shorter?
Click and drag the separator between rows
What do you need to do to accept the changes after editing a cell?
Press Enter without holding down any key
What symbol is used to represent subtraction in an Excel formula?
What is the order of operations in Excel when using several operations in one formula?
Parentheses, Exponents, Multiplication and Division, Addition and Subtraction
What is the term for a value that is directly entered into a formula in Excel?
Literal value
Which of the following is an example of a formula with only cell references?
=A1*B1
What operation is represented by the caret symbol (^) in an Excel formula?
Exponentiation
When writing formulas in Excel, what is recommended to avoid?
Hiding data values within formulas
What is the correct order of operations when evaluating a formula with multiple operations in Excel?
Parentheses, Multiplication and Division, Exponents, Addition and Subtraction
What is the purpose of breaking up formulas to show intermediate results in Excel?
To show how the formula is being evaluated step-by-step
What is the value of 2^5 in data storage?
32
What is the smallest unit of data storage in a computer system?
Bit
What is the equivalent value of 1 kilobyte in bytes?
1024 bytes
What is the equivalent value of 1 gigabyte in bytes?
1,073,741,824 bytes
What is a nibble in data storage?
A 4-bit data item
What is a doubleword in data storage?
A 4-byte data item
What is the equivalent value of 1 terabyte in bytes?
10^12 bytes
Study Notes
Data Storage Hierarchy
- A bit is a binary digit (0 or 1)
- The data storage hierarchy is:
- 2^n (e.g., 2^1 = 2, 2^2 = 4, 2^3 = 8, etc.)
- 2^10 = 1024 (1 KB)
- 2^20 = 1,048,576 (1 MB)
- 2^30 = 1,073,741,824 (1 GB)
- 2^40 = 1,099,511,627,776 (1 TB)
Units of Data Storage
- Bit: a binary digit (0 or 1)
- Byte: 8 bits (basic storage unit in computer systems)
- Kilobyte (KB): 2^10 bytes ≈ 103 bytes
- Megabyte (MB): 2^20 bytes ≈ 1,000,000 bytes
- Gigabyte (GB): 2^30 bytes ≈ 1,000,000,000 bytes
- Terabyte (TB): 2^40 bytes ≈ 1,000,000,000,000 bytes
Other Related Bytes
- Nibble: a half-byte (4-bit)
- Word: a 2-byte (16-bit) data item
- Doubleword: a 4-byte (32-bit) data item
- Quadword: an 8-byte (64-bit) data item
- Paragraph: a 16-byte (128-bit) area
Text, Dates, and Logical Data
- Text: any group of letters, numbers, or special characters
- Text operators: & (concatenation)
- Text functions: right(), left(), mid(), lower(), upper(), len(), etc.
- Dates: date and time values
- Dates operators: N/A
- Dates functions: now(), today(), hour(), minute(), etc.
- Logical: true or false values
- Logical operators: <, >, =, =
- Logical functions: if(), and(), or(), not(), isblank()
Working with Columns and Rows in Excel
- Excel 1997-2003: 256 columns, 65,536 rows
- Excel 2007-2021: 1,048,576 rows, 16,384 columns
- Selecting a cell: click on the cell once, or use the arrow keys or Enter key
- Entering information: type in the cell, and press Enter or click the check button
- Modifying a cell: double-click on the cell, and click and drag the separator to adjust the column width
- Resizing a row: drag the separator between the rows
Working with Cells and Ranges in Excel
- Selecting a large range of cells: click on the upper left cell, hold the shift key, and click on the lower right cell
- Selecting non-contiguous areas: hold the Ctrl key and click on the cells
- Writing a formula: start with an equal sign (=), and use operators (+, -, *, /, ^) and cell references
Data Processing with Microsoft Excel
- Overview of Excel formulas: use an equal sign (=) to indicate a formula, and use operators and cell references
- Guidelines for writing effective formulas: keep them simple, avoid hiding data values, and break up formulas to show intermediate results
- Order of operations in Excel formulas: parentheses, exponents, multiplication and division, and addition and subtraction
This quiz covers the concept of data storage hierarchy, including bits, bytes, and their respective values.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free