BUS 1350 (15) | UPDATED Questions with 100% Verified
Answers
Q1: Microsoft Excel
A: The spreadsheet program in the Microsoft Office suite; used to enter, analyze, and
present quantitative data; also called Excel.
Q2: Excel
A: A spreadsheet program used to enter, analyze, and present quantitative data; also called
Microsoft Excel 2019.
Q3: spreadsheet
A: A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a
worksheet.
Q4: Backstage view
A: The view that contains commands that let you manage the file and program settings.
Q5: template
A: A file with a theme applied and that may contain formatted placeholder text, headers and
footers, and graphics that you replace with your own information for hundreds of
purposes, including budgets, flyers, and resumes; template files have slightly different file
extensions than standard application files, such as .xltx, .pptx., or .dotx.
Q6: keyboard shortcut
A: A key or combination of keys that you press to access a feature or perform a command,
instead of using a mouse or touch gestures.
Q7: ScreenTip
A: A label that appears when you point to a button or object, that may include the name,
purpose, or keyboard shortcut for the object; may also include a link to associated help
topics.
Q8: Key Tips
A: Labels that appear over each tab and command on the ribbon when the ALT key is
pressed.
Q9: Touch Mode
A: The interface that that makes it easier to interact with a computer touchscreen using your
finger instead of a mouse pointer; the ribbon increases in height, the buttons are larger,
and more space appears around buttons so you can more easily use your finger or stylus
, to tap screen elements.
Q10: Mouse Mode
A: A mode in which you use a computer mouse to interact with commands and tools.
Q11: chart sheet
A: A separate sheet in a workbook that contains only a chart, which is linked to the
workbook data.
Q12: cell reference
A: The column letter and row number location that identifies a cell within a worksheet or
table, such as A1.
Q13: range reference
A: The cell reference of the upper-left cell of the rectangular block and the cell reference
of the lower-right cell, separated by a colon.
Q14: shortcut menu
A: A list of frequently used commands that relate to an object, typically displayed by right
clicking; the commands on a shortcut menu are related to the item you right-clicked.
Q15: Text data
A: In Access, data in a field whose data type is Short Text.
Q16: text string
A: In Excel, a series of text characters.
Q17: Numeric data
A: Any number that can be used in a mathematical operation.
Q18: Date data
A: A value in a recognized date format.
Q19: time data
A: A value in a recognized time format.
Q20: AutoComplete
A: A feature that automatically suggests text, numbers, or dates to insert.
Answers
Q1: Microsoft Excel
A: The spreadsheet program in the Microsoft Office suite; used to enter, analyze, and
present quantitative data; also called Excel.
Q2: Excel
A: A spreadsheet program used to enter, analyze, and present quantitative data; also called
Microsoft Excel 2019.
Q3: spreadsheet
A: A grid of cells that contain numbers and text; in Microsoft Excel, a spreadsheet is called a
worksheet.
Q4: Backstage view
A: The view that contains commands that let you manage the file and program settings.
Q5: template
A: A file with a theme applied and that may contain formatted placeholder text, headers and
footers, and graphics that you replace with your own information for hundreds of
purposes, including budgets, flyers, and resumes; template files have slightly different file
extensions than standard application files, such as .xltx, .pptx., or .dotx.
Q6: keyboard shortcut
A: A key or combination of keys that you press to access a feature or perform a command,
instead of using a mouse or touch gestures.
Q7: ScreenTip
A: A label that appears when you point to a button or object, that may include the name,
purpose, or keyboard shortcut for the object; may also include a link to associated help
topics.
Q8: Key Tips
A: Labels that appear over each tab and command on the ribbon when the ALT key is
pressed.
Q9: Touch Mode
A: The interface that that makes it easier to interact with a computer touchscreen using your
finger instead of a mouse pointer; the ribbon increases in height, the buttons are larger,
and more space appears around buttons so you can more easily use your finger or stylus
, to tap screen elements.
Q10: Mouse Mode
A: A mode in which you use a computer mouse to interact with commands and tools.
Q11: chart sheet
A: A separate sheet in a workbook that contains only a chart, which is linked to the
workbook data.
Q12: cell reference
A: The column letter and row number location that identifies a cell within a worksheet or
table, such as A1.
Q13: range reference
A: The cell reference of the upper-left cell of the rectangular block and the cell reference
of the lower-right cell, separated by a colon.
Q14: shortcut menu
A: A list of frequently used commands that relate to an object, typically displayed by right
clicking; the commands on a shortcut menu are related to the item you right-clicked.
Q15: Text data
A: In Access, data in a field whose data type is Short Text.
Q16: text string
A: In Excel, a series of text characters.
Q17: Numeric data
A: Any number that can be used in a mathematical operation.
Q18: Date data
A: A value in a recognized date format.
Q19: time data
A: A value in a recognized time format.
Q20: AutoComplete
A: A feature that automatically suggests text, numbers, or dates to insert.
