Excel Interface
問題一覧
1
tab provides options for changing the view of the spreadsheet, including Normal, Page Layout, and Page Break Preview. It also allows users to split the worksheet into panes for easier navigation.
view options
2
contains tools for spell-checking, tracking changes, adding comments, and protecting worksheets and workbooks.
review and proofing
3
this tab offers features for sorting, filtering, and managing data. It also includes tools for data validation, data import/export, and text-to-columns transformations.
data tools
4
thistab allows users to set up page orientation, page size, margins, and headers/footers for printing worksheets.
page layout
5
can be inserted and customized from the "Insert" tab.
charts
6
is a small square in the lower-right corner of the active cell. It can be used to quickly fill adjacent cells with a series of values or to copy and autofill formulas.
fill handle
7
are predefined operations (e.g., SUM, AVERAGE) that can be used for calculations.
functions
8
start with an equal sign (=) and can include mathematical operators and cell references (e.g., "=A1+B2").
formulas
9
it displays the cell reference or name of the active cell. Users can also use it to quickly navigate to specific cells by entering cell references.
name box
10
displays the content of the active cell, whether it's data, a formula, or a function. Users can edit cell contents directly from this.
formula bar
11
The active cell is outlined, and its address is displayed in the ____ (located to the left of the Formula Bar).
name box
12
a fundamental unit in Excel where data can be entered. Users can input text, numbers, dates, and formulas into this.
cell
13
a fundamental unit in Excel where data can be entered. Users can input text, numbers, dates, and formulas into this
cell
14
The intersection of a row and a column is called a ___ and each this is identified by a unique ____ reference (e.g., A1, B2).
cell
15
run vertically from top to bottom and are labeled alphabetically (A, B, C, ...).
columns
16
run horizontally from left to right and are numbered numerically (1, 2, 3, ...).
rows
17
Each of this can contain text, numbers, formulas, and charts. Users can have multiple worksheets within a single workbook.
worksheet (spreadsheet)
18
grid of rows and columns where users enter, manipulate, and analyze data.
worksheet (spreadsheet)
19
Each of this is displayed in a separate tab at the bottom of the Excel window.
workbook
20
it is also called spreadsheet
workbook
21
the main Excel file that contains one or more worksheets
workbook
22
Users can customize this toolbar by adding their preferred commands.
quick access toolbar
23
is located above the Ribbon and provides quick access to frequently used commands.
quick access toolbar
24
It provides access to most of Excel's features and functionalities, organized into categories like "Home," "Insert," "Page Layout," "Formulas," "Data," "Review," and "View."
ribbon
25
is located at the top of the Excel window and consists of tabs, each containing groups of related commands.
ribbon
26
It has a user-friendly interface with various elements and functionalities that enable users to work with spreadsheets, perform calculations, create charts, and analyze data.
microsoft excel
CPEL
CPEL
Rupac, Ashley May · 46問 · 2年前CPEL
CPEL
46問 • 2年前SAS
SAS
Rupac, Ashley May · 49問 · 2年前SAS
SAS
49問 • 2年前Data Science
Data Science
Rupac, Ashley May · 89問 · 2年前Data Science
Data Science
89問 • 2年前Data Analytics Process
Data Analytics Process
Rupac, Ashley May · 14問 · 2年前Data Analytics Process
Data Analytics Process
14問 • 2年前Data, Data Sources, and Data Types
Data, Data Sources, and Data Types
Rupac, Ashley May · 23問 · 2年前Data, Data Sources, and Data Types
Data, Data Sources, and Data Types
23問 • 2年前Data analytics and its types
Data analytics and its types
Rupac, Ashley May · 18問 · 2年前Data analytics and its types
Data analytics and its types
18問 • 2年前Basic data quality assessment
Basic data quality assessment
Rupac, Ashley May · 20問 · 2年前Basic data quality assessment
Basic data quality assessment
20問 • 2年前Ethical considerations
Ethical considerations
Rupac, Ashley May · 13問 · 2年前Ethical considerations
Ethical considerations
13問 • 2年前問題一覧
1
tab provides options for changing the view of the spreadsheet, including Normal, Page Layout, and Page Break Preview. It also allows users to split the worksheet into panes for easier navigation.
view options
2
contains tools for spell-checking, tracking changes, adding comments, and protecting worksheets and workbooks.
review and proofing
3
this tab offers features for sorting, filtering, and managing data. It also includes tools for data validation, data import/export, and text-to-columns transformations.
data tools
4
thistab allows users to set up page orientation, page size, margins, and headers/footers for printing worksheets.
page layout
5
can be inserted and customized from the "Insert" tab.
charts
6
is a small square in the lower-right corner of the active cell. It can be used to quickly fill adjacent cells with a series of values or to copy and autofill formulas.
fill handle
7
are predefined operations (e.g., SUM, AVERAGE) that can be used for calculations.
functions
8
start with an equal sign (=) and can include mathematical operators and cell references (e.g., "=A1+B2").
formulas
9
it displays the cell reference or name of the active cell. Users can also use it to quickly navigate to specific cells by entering cell references.
name box
10
displays the content of the active cell, whether it's data, a formula, or a function. Users can edit cell contents directly from this.
formula bar
11
The active cell is outlined, and its address is displayed in the ____ (located to the left of the Formula Bar).
name box
12
a fundamental unit in Excel where data can be entered. Users can input text, numbers, dates, and formulas into this.
cell
13
a fundamental unit in Excel where data can be entered. Users can input text, numbers, dates, and formulas into this
cell
14
The intersection of a row and a column is called a ___ and each this is identified by a unique ____ reference (e.g., A1, B2).
cell
15
run vertically from top to bottom and are labeled alphabetically (A, B, C, ...).
columns
16
run horizontally from left to right and are numbered numerically (1, 2, 3, ...).
rows
17
Each of this can contain text, numbers, formulas, and charts. Users can have multiple worksheets within a single workbook.
worksheet (spreadsheet)
18
grid of rows and columns where users enter, manipulate, and analyze data.
worksheet (spreadsheet)
19
Each of this is displayed in a separate tab at the bottom of the Excel window.
workbook
20
it is also called spreadsheet
workbook
21
the main Excel file that contains one or more worksheets
workbook
22
Users can customize this toolbar by adding their preferred commands.
quick access toolbar
23
is located above the Ribbon and provides quick access to frequently used commands.
quick access toolbar
24
It provides access to most of Excel's features and functionalities, organized into categories like "Home," "Insert," "Page Layout," "Formulas," "Data," "Review," and "View."
ribbon
25
is located at the top of the Excel window and consists of tabs, each containing groups of related commands.
ribbon
26
It has a user-friendly interface with various elements and functionalities that enable users to work with spreadsheets, perform calculations, create charts, and analyze data.
microsoft excel