©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
CISM 2530 Chapter 4 Practice Questions and Answers (100% Pass)
Descending - Answer✔️✔️-Which of the following words best describes a Z to A
sort?
Banded Rows - Answer✔️✔️-What is another name for rows that alternate shading
on the rows?
AND condition - Answer✔️✔️-How does Excel treat criteria entered on the same
row?
External data - Answer✔️✔️-Which of the following is data that originates in
another program or format?
Flash Fill - Answer✔️✔️-Which of the following is used for recognizing a pattern in
the first cell and suggesting data for the remaining rows in a column?
.csv - Answer✔️✔️-Which of the following types of files might you see when
downloading a bank statement?
@ - Answer✔️✔️-What symbol precedes all structured references in Formula
AutoComplete lists?
1
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
Complete rows of data - Answer✔️✔️-When you sort a cell range using A to Z or Z
to A, what is rearranged?
Delimiter - Answer✔️✔️-Which of the following is used to separate data?
PivotCharts - Answer✔️✔️-Which of the following can be built from a PivotTable?
True - Answer✔️✔️-True or False
You can copy and paste data from Word into an Excel worksheet.
False - Answer✔️✔️-True or false
You can import text from a Word document directly into Excel.
at least 2 - Answer✔️✔️-How many rows must the criteria range of an Advanced
Filter have?
It is possible to remove a style once you've applied it - Answer✔️✔️-Which of the
following is true about table styles?
All of the above - Answer✔️✔️-Which of the following can you sort Excel data by?
a) cell icon
2
CISM 2530 Chapter 4 Practice Questions and Answers (100% Pass)
Descending - Answer✔️✔️-Which of the following words best describes a Z to A
sort?
Banded Rows - Answer✔️✔️-What is another name for rows that alternate shading
on the rows?
AND condition - Answer✔️✔️-How does Excel treat criteria entered on the same
row?
External data - Answer✔️✔️-Which of the following is data that originates in
another program or format?
Flash Fill - Answer✔️✔️-Which of the following is used for recognizing a pattern in
the first cell and suggesting data for the remaining rows in a column?
.csv - Answer✔️✔️-Which of the following types of files might you see when
downloading a bank statement?
@ - Answer✔️✔️-What symbol precedes all structured references in Formula
AutoComplete lists?
1
, ©PREP4EXAMS 2024/2025 REAL EXAM DUMPS Tuesday, August 6, 2024 10,57 AM
Complete rows of data - Answer✔️✔️-When you sort a cell range using A to Z or Z
to A, what is rearranged?
Delimiter - Answer✔️✔️-Which of the following is used to separate data?
PivotCharts - Answer✔️✔️-Which of the following can be built from a PivotTable?
True - Answer✔️✔️-True or False
You can copy and paste data from Word into an Excel worksheet.
False - Answer✔️✔️-True or false
You can import text from a Word document directly into Excel.
at least 2 - Answer✔️✔️-How many rows must the criteria range of an Advanced
Filter have?
It is possible to remove a style once you've applied it - Answer✔️✔️-Which of the
following is true about table styles?
All of the above - Answer✔️✔️-Which of the following can you sort Excel data by?
a) cell icon
2
