Congratulations Pranay Mehrotra for getting all answers right with minimal attempts and faster than everyone else. You will receive your voucher by mail. Please send us your email id on nitin@maxoffice.biz. Kamal Karnatak was the fastest to solve the quiz.
However, he replied after the published Quiz ending time.
Questions, Answers and Related Articles
This is not just an announcement. It is a reading list as well.
You can learn more about each topic by clicking on the related article link.
-
If you add a shape and make the border transparent, does the width and height reduce?
NO. It does not. The width and height does not count the border width. Removing the border reduces the visual width. Not the actual width.
-
To get the right side shape from the left side shapes which operation is required in merge shapes?
Combine Shapes.
Show Off Demo: Create new shapes in PowerPoint
Merging Shapes – Part 2 -
Excel add-in to capture data from web pages and remember the steps for future reuse is called…?
Power Query
DO NOT copy paste data from browser. Use Power Query.
Bad Data to Good Data: Filling in gaps using Power Query
Facebook analytics using Excel 2013 Power Query: Without programming!
Working with Excel data? There is a revolution happening. Learn Power BI -
Which feature of Excel allows us to highlight data by changing its formatting based upon specific criteria which we can specify?
Conditional Formatting
Worst Practice: Using formatting as a substitute to information
Using color to simplify interpretation and enhance analysis
Show High, Medium, Low values in few clicks
High, Medium, Low – visual categories – In-Depth
How to highlight entire row based upon value in a single column -
What does the FIT option under CROP do in PowerPoint?
Fits the entire image inside the container shape. Maintains the aspect ratio.
How to crop images and videos?
How to Crop – Part 2 -
What is the combination of fonts, colors and shape effects called in Microsoft Office?
-
In Microsoft Word you can have two different headers for two different sections. To do this you must switch off a setting. Which one?
Link to Previous
Word Sections – Part 3 – Headers and Footers
How to create a formal document in Word? -
What do green marks in top left corner of Excel cells mean?
Some potential error which you must handle before trusting the data
Auditors, Risk Managers, Everyone: Did you know? These green marks are WARNINGS!! Green Marks Part 2: Formulas showing wrong results!
Green Marks Part 3: More error handling
Green Marks Part 4: Inconsistent Formulas
Green Marks Part 5/5 (Background Error Checking in Excel)
What next?
In the next article I will cover how exactly this quiz was created using Office Mix.
***
