Computer Fundamentals Week 4

A file in Excel containing one or more worksheets, used to store and organize data, calculations, and analyses​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Workbook

A single page within an Excel workbook where data is entered and managed, forming part of the overall data set in a workbook​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Worksheet

What is the function of the SUM formula in Excel? A. Adds a range of numbers together B. Calculates the average of a range of cells C. Multiplies values in a range D. Finds the maximum value in a range

A. Adds a range of numbers together

You're creating a study plan and need to navigate between cells quickly. Which keyboard shortcuts are most efficient? A. Arrow keys, 'Enter', and 'Tab' B. 'Ctrl + C', 'Ctrl + V' C. 'Ctrl + Z', 'Ctrl + Y' D. 'Alt' keys

A. Arrow keys, 'Enter', and 'Tab'

You're preparing a budget for a group project. Which Excel feature should you use to add up all expenses? A. AutoSum B. Sort & Filter C. Conditional Formatting D. Merge & Center

A. AutoSum

Which of the following is a key component of the Excel workspace? A. Both the Toolbar and the Ribbon B. Ribbon C. None of the answers. D. Toolbar

A. Both the Toolbar and the Ribbon

What does sorting data in Excel primarily allow users to do? A. Organize rows based on numerical or alphabetical order B. Combine multiple cells into one C. Rearrange rows based on colors D. Apply formulas to selected cells

A. Organize rows based on numerical or alphabetical order

A command in Excel's Ribbon used for automatically calculating the sum of a selected range of cells​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

AutoSum

You've entered incorrect data for an assignment due date in Excel. What combination of keys allows you to redo your action after undoing it? A. 'Ctrl + C', 'Ctrl + V' B. 'Ctrl + Y' C. 'Ctrl + Z', 'Ctrl + X' D. 'Alt' keys

B. 'Ctrl + Y'

You want to analyze your monthly spending. Which function would help you find the average spending per month? A. SUM B. AVERAGE C. MAX D. MIN.

B. AVERAGE

You're tracking weekly expenses for a school project. How do you total the expenses for the week in Excel? A. Manually add each expense B. Create a basic math formula for addition C. Use the AVERAGE function D. Sort the expenses in ascending order.

B. Create a basic math formula for addition

Which keyboard shortcut is used to paste values only (without formatting) in Excel? A. Ctrl + V B. Ctrl + Shift + V C. Ctrl + Alt + V D. Ctrl + C

B. Ctrl + Shift + V

To improve readability, you want to adjust the width of columns in your Excel worksheet. What is the quickest way to do this? A. Manually resize each column B. Double-click for AutoFit C. Use the SUM function D. Apply Conditional Formatting.

B. Double-click for AutoFit

How can you start Excel for the first time on a Windows computer? A. From the taskbar B. From the Start Menu C. From the Ribbon D. Excel cannot be started on a Windows computer

B. From the Start Menu

How does enhancing worksheet appearance in Excel benefit data presentation? A. It increases the file size for better quality. B. It improves readability and helps highlight key data. C. It changes the data values for more accurate results. D. It encrypts the worksheet for security.

B. It improves readability and helps highlight key data.

You're organizing a fundraiser and need to combine data from different cells into one. What command should you use? A. AutoSum B. Merge & Center C. Conditional Formatting D. Sort & Filter

B. Merge & Center

During a group project, you need to organize participant names alphabetically. What Excel feature should you use? A. Conditional Formatting B. Sort & Filter C. Merge & Center D. AutoSum.

B. Sort & Filter

While working on a lab report, you need to organize your data alphabetically. Which Excel feature will help? A. AutoSum B. Sort & Filter C. Merge & Center D. Conditional Formatting

B. Sort & Filter

You're entering data about weekly study hours. What types of data can you enter in Excel? A. Images and videos B. Text labels, numerical values, dates C. 3D models D. Audio files

B. Text labels, numerical values, dates

How do you copy a formula from one cell to another in an Excel worksheet? A. Drag the cell to the new location B. Use 'CTRL+C' to copy and 'CTRL+V' to paste C. Write the formula again in the new cell D. Use the AutoSum feature.

B. Use 'CTRL+C' to copy and 'CTRL+V' to paste

During a group study session, you need to quickly copy and paste a list of topics from one worksheet to another in Excel. What's the fastest way? A. Re-type the topics in the new worksheet B. Use 'Ctrl + C' to copy and 'Ctrl + V' to paste C. Drag and drop the topics D. Use the 'Sort & Filter' feature.

B. Use 'Ctrl + C' to copy and 'Ctrl + V' to paste

What is Microsoft Excel primarily used for? A. Database management B. Graphic design C. Data organization, calculation, and analysis D. Word processing

C. Data organization, calculation, and analysis

If you want to define a range of cells to calculate the total score in a class test, what should you do in Excel? A. Use the Sort & Filter feature B. Apply Conditional Formatting C. Define and use a cell range in a formula D. Adjust the column width.

C. Define and use a cell range in a formula

Describe how the VLOOKUP function is utilized in data analysis. A. It visually represents data in a pie chart. B. It deletes unwanted data from the worksheet. C. It searches for a value in a table and returns a value in the same row from a specified column. D. It filters data based on user-defined criteria.

C. It searches for a value in a table and returns a value in the same row from a specified column.

What should you do after attending an Excel lesson to reinforce learning? A. Take a break B. Only read the lecture notes C. Open Excel and explore on your own D. Close Excel and not use it

C. Open Excel and explore on your own

You are preparing a budget report and need the total sales figure. Which Excel function is most appropriate? A. AVERAGE B. MAX C. SUM D. MIN.

C. SUM

You need to format a column in your budget sheet to show values as currency. How do you do this in Excel? A. Use the AVERAGE function B. Sort the column in ascending order C. Select the cells and click '$' on the 'Home' tab D. Double-click the column header.

C. Select the cells and click '$' on the 'Home' tab

What is the advantage of using Pivot Tables in data organization? A. They automatically delete duplicate entries. B. They translate data into multiple languages. C. They summarize and analyze large data sets flexibly. D. They convert all data to currency format.

C. They summarize and analyze large data sets flexibly.

What is the purpose of using the 'Freeze Panes' feature in Excel? A. To add decorative borders to the worksheet. B. To convert the data into charts. C. To keep specific rows or columns visible when scrolling. D. To freeze the data so it cannot be edited.

C. To keep specific rows or columns visible when scrolling.

You've entered your grades in Excel but want to align them to the center for better presentation. Where do you find this option? A. In the File menu B. In the View tab C. Under the 'Home' tab, then 'Alignment' group D. On the Quick Access Toolbar.

C. Under the 'Home' tab, then 'Alignment' group

Individual boxes in an Excel worksheet where data is entered and displayed; fundamental units for storing and manipulating data​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Cells

Lets you emphasize data by changing its appearance in a cell (or range of cells) automatically. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Conditional Formatting

You're summarizing survey results for a class presentation. How can you highlight key data in Excel? A. Use the 'AutoSum' feature B. Use 'Merge & Center' C. Use the 'Sort & Filter' feature D. Apply 'Conditional Formatting'

D. Apply 'Conditional Formatting'

What can you customize in the Excel environment to enhance productivity? A. Excel cannot be customized B. Quick Access Toolbar C. Default settings D. Both Quick Access Toolbar and Default settings

D. Both Quick Access Toolbar and Default settings

How can you make Excel more accessible for frequent use? A. By changing the color theme B. By creating a desktop shortcut C. It's not possible to make Excel more accessible D. Both by changing the color theme and creating a desktop shortcut

D. Both by changing the color theme and creating a desktop shortcut

What does customizing the Quick Access Toolbar involve? A. Changing the toolbar's color B. The Quick Access Toolbar cannot be customized) C. Adding or removing commands D. Both changing the toolbar's color and adding/removing commands

D. Both changing the toolbar's color and adding/removing commands

Which feature allows you to visually represent data in a chart or graph within Excel? A. Sort B. AutoFill C. PivotTable D. Insert Chart

D. Insert Chart

You've made a mistake in your class schedule in Excel. How can you quickly undo this action? A. Use the 'Sort & Filter' feature B. Delete and retype the data C. Close and reopen Excel D. Press 'Ctrl + Z'

D. Press 'Ctrl + Z'

Which feature helps you navigate the Excel interface effectively? A. The title bar B. The scroll bar C. The status bar D. The Ribbon

D. The Ribbon

A powerful spreadsheet tool used for data organization, calculation, and analysis in various academic and professional settings​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Excel

Key combinations like 'Ctrl + Z' for Undo, 'Ctrl + C' for Copy, and 'Ctrl + V' for Paste, used to speed up navigation and data editing in Excel​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Keyboard Shortcuts

A component of the Excel workspace that includes core tabs like Home, Insert, and Page Layout, providing access to commonly used commands and features​​​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Ribbon

Features in Excel used for organizing and analyzing data, allowing users to sort data alphabetically or numerically and filter out specific information based on criteria​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Sort & Filter

Functions in Excel used to organize data in ascending (low to high) or descending (high to low) order, enhancing data analysis and readability​​. Ribbon [] Excel [] Cells [] Workbook [] AutoSum [] Sort & Filter [] Keyboard Shortcuts [] Worksheet [] Conditional Formatting [] Sort Ascending/Descending

Sort Ascending/Descending