|
 Spreadsheet Tools – I 50 Flashcards |
Start
|
|
What are the primary uses of spreadsheets in various fields? |
Card: 1 / 50 |
|
|
SpreadsheetsThe Primary Uses of Spreadsheets in Various Fields
|
Card: 2 / 50 |
|
|
Fill in the blank: A new spreadsheet can be created by opening the software and selecting ___ from the file menu. |
Card: 3 / 50 |
|
|
"New" or "Blank Workbook"  |
Card: 4 / 50 |
|
|
True or False: Spreadsheets should be saved only once after creating the document to ensure data is not lost. |
Card: 5 / 50 |
|
|
False. Spreadsheets should be saved regularly to prevent data loss.  |
Card: 6 / 50 |
|
|
Riddle: I am made up of rows and columns, and I can hold numbers, text, and formulas. What am I? |
Card: 7 / 50 |
|
|
A spreadsheet.  |
Card: 8 / 50 |
|
|
Multiple Choice: Which of the following is NOT an example of spreadsheet software? A) Microsoft Excel B) Google Sheets C) Adobe Photoshop D) LibreOffice Calc |
Card: 9 / 50 |
|
|
C) Adobe Photoshop  |
Card: 10 / 50 |
|
|
What is the importance of regularly saving a spreadsheet? |
Card: 11 / 50 |
|
|
Regularly SavingThe Importance of Saving a Spreadsheet
|
Card: 12 / 50 |
|
|
What is the default alignment for text data in a spreadsheet cell? |
Card: 13 / 50 |
|
|
Text data is left-aligned by default in most spreadsheet software.  |
Card: 14 / 50 |
|
|
The active cell in a spreadsheet is defined as ___ and is indicated by ___ . |
Card: 15 / 50 |
|
|
Active CellSpreadsheet Basics: The Active Cell
|
Card: 16 / 50 |
|
|
True or False: Numeric data in a spreadsheet is typically left-aligned. |
Card: 17 / 50 |
|
|
False. Numeric data is right-aligned by default.  |
Card: 18 / 50 |
|
|
Fill in the blank: To move to the next cell on the right after entering data, you should press ___ . |
Card: 19 / 50 |
|
|
Tab  |
Card: 20 / 50 |
|
|
What types of data can be entered into spreadsheet cells? |
Card: 21 / 50 |
|
|
Cells can hold text, numbers, and dates/times.  |
Card: 22 / 50 |
|
|
Riddle: I can hold numbers, text, or dates, but I'm not a book. What am I? |
Card: 23 / 50 |
|
|
A spreadsheet cell.  |
Card: 24 / 50 |
|
|
How can you edit the contents of an existing cell in a spreadsheet? |
Card: 25 / 50 |
|
|
 Unlock all Flashcards with EduRev Infinity Plan Starting from @ ₹99 only
|
|
|
|
You can edit a cell's contents by double-clicking on the cell or selecting it and typing.  |
Card: 26 / 50 |
|
|
What are some basic formatting options available for enhancing the readability of data in spreadsheets? |
Card: 27 / 50 |
|
|
Basic Formatting OptionsEnhancing Readability in Spreadsheets
|
Card: 28 / 50 |
|
|
Fill in the blank: To remove data from a cell in a spreadsheet, you can select it and press ___ on your keyboard. |
Card: 29 / 50 |
|
|
Delete  |
Card: 30 / 50 |
|
|
True or False: You can format numbers in a spreadsheet as currency, but not as percentages. |
Card: 31 / 50 |
|
|
False. You can format numbers as both currency and percentages.  |
Card: 32 / 50 |
|
|
Riddle: I can be adjusted to show how much of a whole I represent, but I am not a fraction. What am I? |
Card: 33 / 50 |
|
|
Percentage formatting.  |
Card: 34 / 50 |
|
|
What is the purpose of adding borders around cells in a spreadsheet? |
Card: 35 / 50 |
|
|
Adding borders around cells helps define sections of data and creates a clean, organized look. |
Card: 36 / 50 |
|
|
Fill in the blank: Changing the ___ of text can help emphasize certain data points in a spreadsheet. |
Card: 37 / 50 |
|
|
Font style  |
Card: 38 / 50 |
|
|
Multiple Choice: Which formatting option allows you to highlight important data by changing the color of the text? |
Card: 39 / 50 |
|
|
Font Color  |
Card: 40 / 50 |
|
|
What is the significance of formatting numbers with a specific number of decimal places in a spreadsheet? |
Card: 41 / 50 |
|
|
Clarity and AccuracyFormatting Numbers in Spreadsheets
|
Card: 42 / 50 |
|
|
What are the three common formats for representing dates? |
Card: 43 / 50 |
|
|
MM/DD/YYYYCommon Date Formats
|
Card: 44 / 50 |
|
|
Fill in the blank: The SUM function in spreadsheet software is used to ___ a range of numbers. |
Card: 45 / 50 |
|
|
Add  |
Card: 46 / 50 |
|
|
True or False: The AVERAGE function calculates the median of a range of numbers. |
Card: 47 / 50 |
|
|
False. The AVERAGE function calculates the mean, not the median.  |
Card: 48 / 50 |
|
|
What is the initial character that indicates the start of a formula in a spreadsheet? |
Card: 49 / 50 |
|
|
The equal sign (=) indicates the start of a formula.  |
Card: 50 / 50 |
|
|
Completed! Keep practicing to master all of them. |
Restart
|
